SUPPORT / SAMPLES & SAS NOTES
Problem Note 51789: The %DI_MAINTAIN_JOB PURGE_DT parameter might be incorrectly interpreted as '1960-01-01 hh:mm:ss' and fail to purge the intended plans
 |  |  |  |
In SAS® Pack Optimization, the %DI_MAINTAIN_JOB PURGE_DT parameter might be incorrectly interpreted as '1960-01-01 hh:mm:ss' and fail to purge the intended plans. For example, if you specify "'01DEC2013'd" as the value for PURGE_DT, it is incorrectly interpreted as "1960-01-01 hh:mm:ss" by %DI_MAINTAIN_JOB. Messages similar to the following are generated in the purge_po_plans.log after specifying PURGE_DT='01DEC2013'd:
CREATE DATE: TIMESTAMP '1960-01-01 05:12:58'
PLAN SELECTION: CREATED_DT <= TIMESTAMP '1960-01-01 05:12:58' and END_DT <= TIMESTAMP '1960-01-01 05:12:58'
There are no plans to delete
NOTE: szpk_purge_po_plans finished successfully for inputs: CREATED_DT <= TIMESTAMP '1960-01-01 05:12:58' and END_DT <= TIMESTAMP
'1960-01-01 05:12:58' .
Contact Technical Support for a workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Pack Optimization | Linux for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M0 | ||